README

The Rise of Urgent Care Centers: Implications for Competition and Access to Care

Download folder "ucc_replication". This folder contains all the data files and do files to replicate our results.
Our results can be replicated by running "0_Master.do" or by running "1_DataPreProcessing_R2.do" through "8_Robustness_PCSA.do" in order.

Description of main dofiles:
_Master : Master do file that calls do files 1 through 8 in the folder.
0_YTS_UrgentCare_R2_V4 : organizes establishment-level data for urgent care centers from raw YTS data.
1_DataPreProcessing_R2 : organizes data at the ZCTA and HSA level for 2010 to 2017. Merges information on number of UCCs with other market characteristics.
2_DataProcessing_R2 : selects ZCTA data for 2015, creates CON laws instrument, and creates additional variables used in the paper.
3_OrganizeDataMain_R2 : collapses ZCTA level data to PCSA level, imposes market definition, and generates descriptive maps.
4_DescriptivesFinal : creates main descriptive tables and figures in the paper.
5_EntryModels_ZCTA_PCSA : estimates univariate and bivariate probits in the main analysis samples and demographic subsamples, computes entry thresholds.
6_Simulations : creates column 7 of table 2.
7_OrganizeDataRobust_PCSA : organizes data for robustness checks in the appendix.
8_Robustness_PCSA : estimates bivariate probits and entry threshodls for robustness checks in the appendix.

The following dofiles are called within the main dofiles and do not need to be called separately.
Br_EntryThreshold_Bi : computes entry thresholds in the main analysis sample for the bivariate ordered probit.
Br_EntryThreshold_Bi_3t : computes entry thresholds in the main analysis sample for the three-type model
Br_EntryThreshold_Bi_3t_cond : computes conditional entry thresholds in the main analysis sample for the three-type model conditional on the number of hospitals and AUCCs.
Br_EntryThreshold_Bi_3t_Income : computes entry thresholds for the three-type model in the subsamples with above and below median income.
Br_EntryThreshold_Bi_3t_SVI : computes entry thresholds for the three-type model in the subsamples with above and below median SVI.
Br_EntryThreshold_Bi_3t_Uninsured : computes entry thresholds for the three-type model in the subsamples with above and below median uninsured.
Br_EntryThreshold_Bi_Conditional : computes conditional entry thresholds for the bivariate ordered probit conditional on the number of hospitals.
Br_EntryThreshold_Bi_Income : computes entry thresholds for the bivariate ordered probit in the subsamples with above and below median income.
Br_EntryThreshold_Bi_svi : computes entry thresholds for the bivariate ordered probit in the subsamples with above and below median SVI.
Br_EntryThreshold_Bi_Uninsured : computes entry thresholds for the bivariate ordered probit in the subsamples with above and below median uninsured.
Br_EntryThreshold_Bi_og : computes entry thresholds for the univariate ordered probit in the main analysis sample.
brentry_bioprobit_negbin_3t_v2 : computes the likelihood function for three-type model.
brentry_bioprobit_negbin_v3 : computes the likelihood function for the bivariate ordered probit.
brentry_v2 : computes the likelihood function for the univariate ordered probit.
YTS_UrgentCare_P1_V2 : identifies urgent care centers in YTS based on UCC opeartos names in SolvHealth.

Folders:
county_shapefiles : contains .dbf and .shp files for all counties in the US. Obtained from census.gov.
hsa_shapefile : contains .dbf and .shp files for all HSAs in the US. Obtained from Dartmouth Atlas.
pcsa_shapefiles : contains .dbf and .shp files for all PCSAs in the US. Obtained from Dartmouth Atlas.
us_zhape_files : contains .dbf and .shp files for all states in the US. Obtained from census.gov.
zcta_shapefiles : contains .dbf and .shp files for all ZCTAs in the US. Obtained from census.gov.

Source data files:
CMSWageIndex : contains 2016 county level CMS wage index.
HospitalsGeocoded : contains longitude and latitude, and other hospital characteristics for every hospital in CMS' Hospital Compare database from 2005 to 2019.
IPUMSAllDemog : contains ZCTA-level demographic characteristics. Obtained from 5-year ACS from 2013 to 2017 from NHGIS IPUMS.
IPUMSHousing : contains ZCTA-level housing characteristics. Obtained from 5-year ACS from 2013 to 2017 from NHGIS IPUMS.
IPUMSMobilityZCTA : contains ZCTA-level migration. Obtained from 5-year ACS from 2013 to 2017 from NHGIS IPUMS.
IPUMSPopGrowth : contains ZCTA-level population growth. Obtained from 5-year ACS from 2013 to 2017 from NHGIS IPUMS.
IPUMSRentZCTA : contains ZCTA-level median rent. Obtained from 5-year ACS from 2013 to 2017 from NHGIS IPUMS.
SVIDataCounty : contains county level Social Vulnerability Index. Obtained from the Agency for Toxic Substances and Disease Registry at the CDC.
UrgentCare_R3 : contains establishment-level data for urgent care centers from 2005 to 2017, including establishment name, geolocation, and industry codes.
ZCTAToRural : contains rural indicator for each ZCTA.
zcta_pcsa : crosswalk from ZCTAs to PCSAs.
ZipHsaHrr15 : crosswalk from Zip codes to HSAs and HRRs.
ZiptoZCTA : crosswalk from Zip codes to ZCTAs.

All other files in the "ucc_replication" folder that are not referenced in this README are created when running the main dofiles. 
